Trace

Net•Yield is fully integrated with the TraceRegister service. As orders are shipped and made ready and/or Invoices are generated and kept in the system, the Trace XML Import Trace Document is automatically created and sent to the TraceRegister service website where the status is updated from Sent, to Received, Validated, Reprocessed, Imported or Failed. The system will only allow invoices with a status of "Imported" to be posted to the Accounts Receivable in Invoice Posting and during the Close End of Day process. Prior to posting the invoice to accounts receivables the system will use the NetTrace utility to automatically connect to the TraceRegister service website and retrieve an updated status.

The Status of each invoice can also be updated manually by using the Trace menu option.

Select Trace from the menu.

The message line will display "Locating Trace Documents ... Please wait" to indicate that the system is locating all XML Import Trace Documents that do not have a status of Imported.

Another message line will display "Waiting for acknowledgement of receipt of XX Invoices XX seconds remaining" to indicate how many invoices need to be sent to the Trace system.

Another message line will display "Waiting while Trace returns the status on XX Invoices XX seconds remaining" to indicate how many invoices need to have their status updated. The system will automatically update the status of each invoice.

Depending on the number of invoices needed to be sent or status updated, the NetTrace Interface dialog box may open to indicate the progress of the transfer of the document to the TraceRegister service website and the Document Status. The dialog box contains the following fields:

• Process Status - Either Connecting if trying to connect to the website or Connected indicating a connection has been made.
• Order Number - indicates the order number being processed.
• Document Status - The initial status is Uploading to indicate the file is being sent to the TraceRegister website. After sending the file, the system will look for an updated status from Trace. The document should come back with a Received status.

Once NetTrace has completed updating the status of each invoice, the following selection box will appear.

• T - used to tag a specific transaction on the list to change a transaction with a Failed Status. The transaction can be tagged so it can be fixed, deleted, or recreated. See Status below.
• Status - indicates the current Trace processing Status.
  • Send - the XML Import Trace Document was created for the sales order or invoice but will not be sent because the "Send on Order or Invoice Trace" setting in Interface Options is set to N, the invoice will post to receivables in Invoice Posting and during the Close End of Day process and the NetTrace utility program will not look to send the documents or retrieve an updated status.
    • The Send document can be deleted by scrolling to the transaction and pressing enter.
    • An Option box will appear with the following options:
      • Exit - select to exit with updating.
      • Delete - select Delete to delete the XML Import Trace Document and remove it from the Trace Transaction window.
  • Posted - the Invoice was posted to receivables but will not be sent because the "Send on Order or Invoice Trace" setting in Interface Options is set to N, the invoice will post to receivables in Invoice Posting and during the Close End of Day process and the NetTrace utility program will not look to send the documents or retrieve an updated status.
  • The Posted document can be deleted by scrolling to the transaction and pressing enter.
  • An Option box will appear with the following options:
    • Exit - select to exit with updating.
    • Delete - select Delete to delete the XML Import Trace Document and remove it from the Trace Transaction window.
  • Sent – means that NetTrace utility has sent the document but it has not been received by Trace Register.
  • Received – means the document has been received by the Trace Register website and is staged and ready to be processed.
  • Validated – means the Trace Register website has reviewed the file and it appears to be a properly formed.
  • Reprocess - means that the Trace Register website successfully processed the file but there were warnings. The warnings follow the status. System will automatically try to resolve warnings usually in the case where traceable source products were defined but a match was not able to be made. The system will reprocess these records once a day for 14 days. If at any time during that period that it was able to resolve all issues the status will be set to “imported”. If after 14 attempts to resolve and issue remain the status will be set to “reprocessed” and no additional attempts to resolve will be made.
  • Imported – means that the file was imported successfully by the TraceRegister service website and there were no errors or warnings. Once the status of imported is returned, the invoice can be posted and the XM Import Trace Document will be moved to the history folder. Transactions with a status of Imported will not appear in the selection box.
  • Failed – means that the file contained one or more fatal errors and could not be processed by the TraceRegister service website. The failed transaction will no longer be updated.
    • Scroll to the failed transaction and press enter. It must be Fixed, Recreated or Deleted
  • A Trace Problem window will appear with the following options:
    • The XML Trace Import Document number and the details of the XML segments that failed with the following command line options:
      • Exit - select to exit with updating.
      • Fix "Trace Attribute" - select to fix the trace attribute error. The user can fix missing or incorrect vendor trace id, country id, and missing required attributes. If the attribute is fixed on one document, the system will also correct any other documents with the same error.
      • Recreate - select Recreate to reissue the XML Import Trace Document.
      • Delete - select Delete to delete the XML Import Trace Document. Transactions that are deleted will be copied to the History file with the current status.

  Failed and Reprocessed transactions that cannot be corrected by recreating must be deleted. If the status is REPROCESS, you will have the same options to recreate or delete as you do with a FAILED document.

  • Order- The sales order number for the transaction.
  • Customer - The ship-to customer ID.
  • Date- The ship date if the transaction is a shipped or ready order - the invoice date for invoiced orders.
  • Error - The Trace error id. See the list of errors below.
  • Reason - A brief description of the error found along with the transaction number and/or attribute id.

   

  If XML Import fails or requires reprocessing, the following error/warning codes will be returned by the Trace system with the error message. 

  Error Description

  • 001 Missing Supplier ID - General cause is the Vendor does not have a Trace ID. Add the Trace ID for the vendor in Vendor or by using the Fix Vendor Trace ID in Trace .
  • 100 Transaction ID does not exist - General cause is the Transaction ID specified could not be found in any of the files uploaded. Check the Transaction ID and or verify that the import file was successfully uploaded.
  • 101 Login failed.- General cause is the Trace login information is in correct. Check the information entered in Interface Options.
  • 102 Validation failure.
  • 103 Invalid XML Syntax.
  • 111 Invalid Account ID.
  • 112 Invalid User ID.
  • 131 Trace Link could not be established - less than 2 source attributes specified.
  • 132 Trace Link could not be established - source product matches 2 or more received products – will try to reprocess.
  • 133 Invalid Supplier ID. - The supplier ID is incorrect or not register with Trace. Check the vendor ID and re-send
  • 141 Invalid Country ID.- The Country ID for the COOL Identity supplied is incorrect or not in the Trace Country tables. Check the country id and resend
  • 151 Duplicate attribute.
  • 152 Attribute – Invalid number.
  • 153 Attribute - Invalid Date.
  • 154 Attribute - Invalid length.
  • 155 Attribute – Invalid.
  • 156 Attribute - Invalid UOM ID.
  • 157 Missing required Attribute.
  • 161 Certification Invalid.

If all documents have Imported successfully the following message will appear: "All Trace Transactions have been imported !!! Space Bar to Continue" and the status box will not appear all invoice will post to accounts receivables.

Select F10 to exit

Note: If the "Send on Order or Invoice Trace" setting in Interface Options, is set to N, the invoice will post to receivables in Invoice Posting and during the Close End of Day process and the NetTrace utility program will not look to send the documents or retrieve an updated status.

Additional Information about Trace is found in the Trace Overview

Security Required : System - System Administration